<?php

/**
 * This is the model class for table "periodoslectivos".
 *
 * The followings are the available columns in table 'periodoslectivos':
 * @property integer $id_periodo
 * @property string $inicio
 * @property string $fin
 * @property boolean $periodo_actual
 *
 * The followings are the available model relations:
 * @property Cursos[] $cursoses
 */
class Periodoslectivos extends CActiveRecord
{
	/**
	 * @return string the associated database table name
	 */
	public function tableName()
	{
		return 'periodoslectivos';
	}

	/**
	 * @return array validation rules for model attributes.
	 */
	public function rules()
	{
		// NOTE: you should only define rules for those attributes that
		// will receive user inputs.
		return array(
			array('inicio, fin, periodo_actual', 'required'),
			// The following rule is used by search().
			// @todo Please remove those attributes that should not be searched.
			array('id_periodo, inicio, fin, periodo_actual', 'safe', 'on'=>'search'),
			array('fin', 'compare', 'compareAttribute'=>'inicio','operator'=>'>'),
		);
	}

	/**
	 * @return array relational rules.
	 */
	public function relations()
	{
		// NOTE: you may need to adjust the relation name and the related
		// class name for the relations automatically generated below.
		return array(
			'cursoses' => array(self::HAS_MANY, 'Cursos', 'id_periodo'),
		);
	}

	/**
	 * @return array customized attribute labels (name=>label)
	 */
	public function attributeLabels()
	{
		return array(
			'id_periodo' => 'Id Periodo',
			'inicio' => 'Inicio del periodo lectivo',
			'fin' => 'Fin del periodo lectivo',
			'periodo_actual' => 'Periodo Actual',
		);
	}

	/**
	 * Retrieves a list of models based on the current search/filter conditions.
	 *
	 * Typical usecase:
	 * - Initialize the model fields with values from filter form.
	 * - Execute this method to get CActiveDataProvider instance which will filter
	 * models according to data in model fields.
	 * - Pass data provider to CGridView, CListView or any similar widget.
	 *
	 * @return CActiveDataProvider the data provider that can return the models
	 * based on the search/filter conditions.
	 */
	public function search()
	{
		// @todo Please modify the following code to remove attributes that should not be searched.

		$criteria=new CDbCriteria;

		$criteria->compare('id_periodo',$this->id_periodo);
		$criteria->compare('inicio',$this->inicio,true);
		$criteria->compare('fin',$this->fin,true);
		$criteria->compare('periodo_actual',$this->periodo_actual);

		return new CActiveDataProvider($this, array(
			'criteria'=>$criteria,
		));
	}

	/**
	 * Returns the static model of the specified AR class.
	 * Please note that you should have this exact method in all your CActiveRecord descendants!
	 * @param string $className active record class name.
	 * @return Periodoslectivos the static model class
	 */
	public static function model($className=__CLASS__)
	{
		return parent::model($className);
	}

	protected function afterSave()
	{
		parent::afterSave();
		if ($this->periodo_actual == true)
		{
			$periodos = Periodoslectivos::model()->findAllByAttributes(
				array('periodo_actual'=>true),
				array(
					'condition'=>'id_periodo <> :periodo',
					'params'=>array(':periodo'=>$this->id_periodo),
					)
				);
			foreach ($periodos as $periodo) {
				$periodo->periodo_actual = 0;
				$periodo->validate();
				$periodo->save();
			}
		}
	}
	
	function getDisplay() // Función en que concatena la fecha inicial y final del periodo lectivo
	{
	    return $this->inicio.' al '.$this->fin;
	}

}
